create external table jms_dm.dm_false_send_xyf_summary_dt (
     network_code            string         comment'网点编码'
    ,network_name            string         comment'网点名称'
    ,agent_code              string         comment'代理区编码'
    ,agent_name              string         comment'代理区名称'
    ,virt_code               string         comment'虚拟代理区编码'
    ,virt_name               string         comment'虚拟代理区名称'
    ,total_cnt               bigint         comment'揽收后超24小时量'
    ,taking_date             string         comment'揽收日期'
    ,customer_order_date     string         comment'下单日期'
) comment '逍遥峰虚假发货明汇总'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_false_send_xyf_summary_dt'
tblproperties (
'discover.partitions'='false' ,
'parquet.column.index.access'='true'
);